package com.example.springboot.mapper;

import com.example.springboot.entity.EthnicPopulation;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface EthnicPopulationMapper {


//Mysql查询2022年名族人口数据
    @Select("SELECT * FROM ethnic_population WHERE year = 2022")
    List<EthnicPopulation> selectByEthnic2022();

    //Mysql查询所有数据
    @Select("SELECT * FROM ethnic_population")
    List<EthnicPopulation> selectByEthnicAll();
}
